Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_FILE_GROUP_TABLES

`ALL_FILE_GROUP_TABLES` shows information about the tables accessible to the current user that can be imported using the file set.

Related Views

- `DBA_FILE_GROUP_TABLES` shows information about all the tables in the database that can be imported using the file set.

- `USER_FILE_GROUP_TABLES` shows information about tables owned by the current user that can be imported using the file set. This view does not display the `FILE_GROUP_OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`FILE_GROUP_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the file group
`FILE_GROUP_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the file group
`VERSION_NAME` | `VARCHAR2(30)` | `NOT NULL` | Version of the file group that contains the table
`VERSION` | `NUMBER` | `NOT NULL` | Internal version number
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Schema to which the table belongs
`TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the table
`TABLESPACE_NAME` | `VARCHAR2(30)` |  | Name of the tablespace to which the table belongs
`SCN` | `NUMBER` |  | SCN at which the table was exported (available only for Streams-prepared tables)